Chapter I - Statistics I - Exercises

This is a set of exercises created by the teaching Faculty for Statistics I, Chapter I - Index Numbers, from the Lisbon Accounting and Business School.

Questions

Question 1

Consider the following sales data, in thousands of euros, for a given company:

Year 2019 2020 2021 2022 2023 2024
Sales 500 650 600 800 750 950
  1. Build the index series with fix base in 2019.
Year 2019 2020 2021 2022 2023 2024
\(I^{sales}_{t|2019}\)
  1. We could say that in year 2021, according to the index computed above, sales increased 20% relative to the base year.

  2. Study the evolution of sales, between consecutive years.

We need to compute the link or chain index.

Year 2019 2020 2021 2022 2023 2024
Sales 500 650 600 800 750 950
\(I^{sales}_{chain}\) 130 92.3 133.3 93.8 126.7

From 2019 to 2020 sales grew by 30%, from 2020 to 2021 sales diminished 7.7%, from 2021 to 2022 sales grew 33.3%, from 2022 to 2023 sales dropped 6.2%, and from 2023 to 2024 sales grew 26.7%.

  1. What happened to sales during the whole studied period?

Sales grew 90%, between 2019 and 2024.

  1. The growth rate between 2021 and 2023 was

  2. The (rounded) average growth rate in the studied period is

Question 2

Consider the following sales data, in thousands of euros, for a given company:

Year 2019 2020 2021 2022 2023 2024
Sales 300 250 \(a\) 240 \(b\) 340
  1. The average growth rate for sales, between 2019 and 2024 was, approximately, 2.53%.

  2. Let \(i_{2021|2019}=67\). Also, assume you know that the growth rate doubled between 2022 and 2023. The values for \(a\) and \(b\) are respectively:

  3. The average growth rate needed to triple sales between 2024 and 2028 would have to be 31.61%.

  4. Assuming an average growth rate of 10%, it would be necessary to wait for 6 years for sales to triple.

Question 3

A given company presented their financial statements with the following information:

Year 2019 2020 2021 2022 2023 2024
Growth rate of sales 20% 15% 20% 10% 25%
Price Index (base = 2021) 81.17 89.29 100 115 128.8 148.12
  1. Write the average growth rate of (nominal) sales for the whole period (rounded up, for example 11 if percentage, or 0.11 if decimal):

  2. Find the annual real growth rate for sales, when this was negative.

Start building the index for sales, base 2021, and remember \(i^v_{t|b}=i^q_{t|b}\times i^p_{t|b}\) to build the real growth rates:

Year 2019 2020 2021 2022 2023 2024
Sales Index (base = 2021) 72.46 86.96 100 120 132 165
Price Index (base = 2021) 81.17 89.29 100 115 128.8 148.12
Real Sales Index (base = 2021) 89.27 97.39 100 104.35 102.48 111.4

Clearly, the real growth rate was negative in 2023, and it was -1.79%.

  1. How do you interpret the price index for years 2019 and 2020?

From 2019 to 2021 prices grew 23.2 %, and from 2020 to 2021 prices grew 11.99 %.

Question 4

For some country, water consumption in the period 2016 and 2024 evolved according the simple index, base 2021, shown in the following table:

Year 2016 2017 2018 2019 2020 2021 2022 2023 2024
Sales Index (base = 2021) 75.6 78.5 82.5 88.1 93.8 100 104.8 107.7 107.9
  1. Water consumption betwee 2018 and 2020 grew 12.5%.

  2. The chain index of 2018 and 2019 are respectively equal to 105.1 and 106.8.

  3. Taking yera 2016 as base year, \(i_{2024|2016}\) would be equal to:

  4. The average growth rate for water consumption in the whole period was 4.54%. Overall, during the whole period, water consumption grew 36.32%.

Question 5

Wayne Industries reported sales using the chain index shown in the following table:

Year 2018 2019 2020 2021 2022 2023 2024
Sales Index 120 125 135 145 150 160 165
  1. The average growth rate between 2018 and 2024 was approximately:

  2. The growth rate for sales between 2017 and 2024 is approximately:

  3. The average semi-annual growth rate between 2020 and 2023 is approximately 23.10%.

  4. The value for the semi-annual growth rate, in real terms, if the IPC (fix base) went from 130 in 2020 to 180 in 2023, is approximately equal to 10%.

Question 6

Consider the following data regarding nominal wages for the workers of Watto’s Junkyard. You also have the inflation rate in Tatooine, for the period 2020 and 2024.

Year 2020 2021 2022 2023 2024
Wage Index (base 2021) 93.5 100 104.3 103.8 109.7
Inflation rate 3.0% 2.4% 2.8% 2.3 % 3.0%
  1. The nominal wage growth rate, from 2020 to 2024, is 17.33%.
  2. The average growth rate of inflation between 2020 and 2024 is 2%.
  3. Fill the following table (use 2 decimal places, for example 101.01):
Year 2021 2022 2023 2024
Linked-Chain Index for wages
  1. The year where the wages had the largest real increase was .

Question 7

Consider the following data with respect to the evolution of the Euro Area GDP (EU27) between 2017 and 2023, constant prices (base 2015), as well as the chain index for prices for the same period:

indicator 2017 2018 2019 2020 2021 2022 2023 2024
GDP 11106306 11334208.4 11547055.1 10905718.3 11590843.7 11988631.7 12054187.6 12184743.8
CPI_link NA 101.8 101.4 100.7 102.9 109.2 106.4 102.6
  1. The inflation rate between 2021 and 2022 was 6.12%.

  2. Prices grew from 2020 to 2024 1.89%.

  3. The average growth rate between 2024 and 2017, for GDP, was 1.33 % every year.

  4. In 2023 and 2024 the real and nominal growth rates (for GDP) were the same.

Question 8

The table below has data on regular consumption goods. You will find prices and quantities, before and after austerity measures were put in place for a economically struggling country. In this period, the LQI and PQI were 91.4 and 91.3 respectively.

Products Before austerity After austerity
Price Quantity Price Quantity
Bread (units) 0.2 420 0.25 360
Milk (Lts) 0.7 360 0.80 336
  1. Assume the time window, between the two periods, was 3 years. The average growth rate for the price of bread was: %. (use two decimals, for example 9.81)

  2. According to the Fisher index, in the studied period, the variation of consumed quantities, for both products, was negative and equal to -8.65%.

  3. The real and nominal growth rates, for sales, for both products, were similar after the implementation of the austerity measures.

  4. Suppose that after the implementation of the austerity measures, and until now, the price of milk dropped 5%. Then, the current price for milk would be (again, use two decimal places, for example 0.56)

Question 9

Public Transportation Year 1 Year 2
Trips Price per trip Trips Price Index (Base: year 1)
Bus 1,763,521 1.15 1,875,345 108.70
Metro 3,148,350 1.2 3,396,138 112.50
  1. According to the LPI for year 2, prices for public transportation grew 11.17% compared to year 1.

  2. The real change, according to PQI in year 2, was 7.35% compared to year 1.

  3. The composite index for value, in the public transportation sector, for year 2 compared to year 1, represents what type of change?

Question 10

After tracking a basket with 30 goods for 3 years (2022 to 2024), the following data was collected:

2022 2023 2024
2022 \(\sum p^k_{2022}q^k_{2022} = 8,562\) \(\sum p^k_{2022}q^k_{2023}=9,210\) \(\sum p^k_{2022} q^k_{2024} = 9,920\)
2023 \(\sum p^k_{2023}q^k_{2022} = 9,150\) \(\sum p^k_{2023}q^k_{2023} = 9,584\)
2024 \(\sum p^k_{2024}q^k_{2022}=9,657\) \(\sum p^k_{2024}q^k_{2024} = 10,013\)

Fill the following table (use index in hundreds, rounded to the closest integer, for example 107):

2022 2023 2024
\(LPI_{t|2022}\) 100
\(PPI_{t|2022}\) 100
\(FPI_{t|2022}\) 100

Question 11

An Index Number is used:
An index number is expressed as
A price index number, computed with a constant reference is:
The most adequate average to compute the average growth rate, for example, for prices, is:
The Consumer Price Index (CPI) is computed using:
Which of the following passes the test of time reversion?
An index number, computed using Fisher’s formula is considered ideal because passes:
From the following identities, select the FALSE one

The real growth rate, within a given timeframe, corresponds to the nominal growth rate, deflated by the CPI (consumer price index).